﻿using System;
namespace BZZ.Model
{
	/// <summary>
	/// 书籍内容实体类：bookChapter 。
	/// </summary>
	[Serializable]
	public class bookChapter
	{
		public bookChapter()
		{}

		#region Model
		private int _id; //id
		private int _bookid; //书编号
		private int _chapterID; //章节序号
		private string _title; //标题
		private string _summary; //摘要
		private string _bookContent; //内容
		private DateTime? _addDate; //添加时间
		private DateTime? _updateDate; //最后修改时间
		private int _sortid; //排序
		private string _ext1; //扩展1
		private string _ext2; //扩展2


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 书编号
		/// </summary>
		public int bookid
		{
			set{ _bookid=value;}
			get{return _bookid;}
		}
        /// <summary>
		/// 章节序号
		/// </summary>
		public int chapterID
		{
			set{ _chapterID=value;}
			get{return _chapterID;}
		}
        /// <summary>
		/// 标题
		/// </summary>
		public string title
		{
			set{ _title=value;}
			get{return _title;}
		}
        /// <summary>
		/// 摘要
		/// </summary>
		public string summary
		{
			set{ _summary=value;}
			get{return _summary;}
		}
        /// <summary>
		/// 内容
		/// </summary>
		public string bookContent
		{
			set{ _bookContent=value;}
			get{return _bookContent;}
		}
        /// <summary>
		/// 添加时间
		/// </summary>
		public DateTime? addDate
		{
			set{ _addDate=value;}
			get{return _addDate;}
		}
        /// <summary>
		/// 最后修改时间
		/// </summary>
		public DateTime? updateDate
		{
			set{ _updateDate=value;}
			get{return _updateDate;}
		}
        /// <summary>
		/// 排序
		/// </summary>
		public int sortid
		{
			set{ _sortid=value;}
			get{return _sortid;}
		}
        /// <summary>
		/// 扩展1
		/// </summary>
		public string ext1
		{
			set{ _ext1=value;}
			get{return _ext1;}
		}
        /// <summary>
		/// 扩展2
		/// </summary>
		public string ext2
		{
			set{ _ext2=value;}
			get{return _ext2;}
		}
		#endregion Model

		#region txt document
		/*
书籍内容,bookChapter
id,书编号,章节序号,标题,摘要,内容,添加时间,最后修改时间,排序,扩展1,扩展2
id,bookid,chapterID,title,summary,bookContent,addDate,updateDate,sortid,ext1,ext2
i,i,i,c200,c500,t,d,d,i,c100,c200


--------------------------
-- 创建表[书籍内容]开始: 
-- alter table  [BZZ_bookChapter] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='BZZ_bookChapter') drop table BZZ_bookChapter
  CREATE TABLE [BZZ_bookChapter] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [bookid] int,
	 [chapterID] int,
	 [title] [varchar] (200),
	 [summary] [varchar] (500),
	 [bookContent] [text],
	 [addDate] [datetime],
	 [updateDate] [datetime],
	 [sortid] int,
	 [ext1] [varchar] (100),
	 [ext2] [varchar] (200)
  )

 exec sp_addextendedproperty N'MS_Description',N'书籍内容 ',N'user',N'dbo',N'table',N'BZZ_bookChapter', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'BZZ_bookChapter',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'书编号',N'user',N'dbo',N'table',N'BZZ_bookChapter',N'column',N'bookid'
 exec sp_addextendedproperty N'MS_Description',N'章节序号',N'user',N'dbo',N'table',N'BZZ_bookChapter',N'column',N'chapterID'
 exec sp_addextendedproperty N'MS_Description',N'标题',N'user',N'dbo',N'table',N'BZZ_bookChapter',N'column',N'title'
 exec sp_addextendedproperty N'MS_Description',N'摘要',N'user',N'dbo',N'table',N'BZZ_bookChapter',N'column',N'summary'
 exec sp_addextendedproperty N'MS_Description',N'内容',N'user',N'dbo',N'table',N'BZZ_bookChapter',N'column',N'bookContent'
 exec sp_addextendedproperty N'MS_Description',N'添加时间',N'user',N'dbo',N'table',N'BZZ_bookChapter',N'column',N'addDate'
 exec sp_addextendedproperty N'MS_Description',N'最后修改时间',N'user',N'dbo',N'table',N'BZZ_bookChapter',N'column',N'updateDate'
 exec sp_addextendedproperty N'MS_Description',N'排序',N'user',N'dbo',N'table',N'BZZ_bookChapter',N'column',N'sortid'
 exec sp_addextendedproperty N'MS_Description',N'扩展1',N'user',N'dbo',N'table',N'BZZ_bookChapter',N'column',N'ext1'
 exec sp_addextendedproperty N'MS_Description',N'扩展2',N'user',N'dbo',N'table',N'BZZ_bookChapter',N'column',N'ext2'

-- 创建表[书籍内容]结束。 
--------------------------

		*/
		#endregion document
	}
}

